Overview
Brought to you by YData
Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 2259077 |
| Missing cells | 3461559 |
| Missing cells (%) | 7.7% |
| Duplicate rows | 62285 |
| Duplicate rows (%) | 2.8% |
| Total size in memory | 1.8 GiB |
| Average record size in memory | 838.7 B |
Variable types
| Text | 4 |
|---|---|
| Numeric | 7 |
| Categorical | 7 |
| DateTime | 1 |
| URL | 1 |
| Dataset has 62285 (2.8%) duplicate rows | Duplicates |
drive is highly overall correlated with type | High correlation |
odometer is highly overall correlated with predicted_price and 1 other fields | High correlation |
predicted_price is highly overall correlated with odometer and 2 other fields | High correlation |
price is highly overall correlated with odometer and 1 other fields | High correlation |
type is highly overall correlated with drive | High correlation |
year is highly overall correlated with predicted_price | High correlation |
title is highly imbalanced (77.3%) | Imbalance |
fuel is highly imbalanced (75.7%) | Imbalance |
transmission is highly imbalanced (67.7%) | Imbalance |
make has 46488 (2.1%) missing values | Missing |
predicted_price has 568801 (25.2%) missing values | Missing |
residual has 568801 (25.2%) missing values | Missing |
condition has 364408 (16.1%) missing values | Missing |
model has 190148 (8.4%) missing values | Missing |
paint has 614472 (27.2%) missing values | Missing |
drive has 663908 (29.4%) missing values | Missing |
type has 444260 (19.7%) missing values | Missing |
Reproduction
| Analysis started | 2024-11-26 19:59:48.844520 |
|---|---|
| Analysis finished | 2024-11-26 20:03:44.974524 |
| Duration | 3 minutes and 56.13 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
location
Text
| Distinct | 413 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 122.0 MiB |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 7.6488238 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | sfbay |
|---|---|
| 2nd row | phoenix |
| 3rd row | sandiego |
| 4th row | miami |
| 5th row | janesville |
| Value | Count | Frequency (%) |
| miami | 201455 | 8.9% |
| sfbay | 140440 | 6.2% |
| losangeles | 103115 | 4.6% |
| phoenix | 91267 | 4.0% |
| portland | 65037 | 2.9% |
| seattle | 64895 | 2.9% |
| sandiego | 60512 | 2.7% |
| sacramento | 56255 | 2.5% |
| orangecounty | 51072 | 2.3% |
| dallas | 48083 | 2.1% |
| Other values (403) | 1376946 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1979088 | |
| e | 1643865 | 9.5% |
| n | 1535769 | 8.9% |
| o | 1469402 | 8.5% |
| s | 1337609 | 7.7% |
| i | 1236133 | 7.2% |
| l | 1184796 | 6.9% |
| t | 951524 | 5.5% |
| r | 809476 | 4.7% |
| m | 749089 | 4.3% |
| Other values (16) | 4382531 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 17279282 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1979088 | |
| e | 1643865 | 9.5% |
| n | 1535769 | 8.9% |
| o | 1469402 | 8.5% |
| s | 1337609 | 7.7% |
| i | 1236133 | 7.2% |
| l | 1184796 | 6.9% |
| t | 951524 | 5.5% |
| r | 809476 | 4.7% |
| m | 749089 | 4.3% |
| Other values (16) | 4382531 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 17279282 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1979088 | |
| e | 1643865 | 9.5% |
| n | 1535769 | 8.9% |
| o | 1469402 | 8.5% |
| s | 1337609 | 7.7% |
| i | 1236133 | 7.2% |
| l | 1184796 | 6.9% |
| t | 951524 | 5.5% |
| r | 809476 | 4.7% |
| m | 749089 | 4.3% |
| Other values (16) | 4382531 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 17279282 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1979088 | |
| e | 1643865 | 9.5% |
| n | 1535769 | 8.9% |
| o | 1469402 | 8.5% |
| s | 1337609 | 7.7% |
| i | 1236133 | 7.2% |
| l | 1184796 | 6.9% |
| t | 951524 | 5.5% |
| r | 809476 | 4.7% |
| m | 749089 | 4.3% |
| Other values (16) | 4382531 |
price
Real number (ℝ)
High correlation 
| Distinct | 10776 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10617.864 |
| Minimum | 255 |
|---|---|
| Maximum | 74999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.2 MiB |
Quantile statistics
| Minimum | 255 |
|---|---|
| 5-th percentile | 1995 |
| Q1 | 4250 |
| median | 7000 |
| Q3 | 13000 |
| 95-th percentile | 31900 |
| Maximum | 74999 |
| Range | 74744 |
| Interquartile range (IQR) | 8750 |
Descriptive statistics
| Standard deviation | 10264.764 |
|---|---|
| Coefficient of variation (CV) | 0.96674474 |
| Kurtosis | 7.6803745 |
| Mean | 10617.864 |
| Median Absolute Deviation (MAD) | 3500 |
| Skewness | 2.4613043 |
| Sum | 2.3986573 × 1010 |
| Variance | 1.0536539 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4500 | 52130 | 2.3% |
| 3500 | 51389 | 2.3% |
| 5500 | 48868 | 2.2% |
| 6500 | 48709 | 2.2% |
| 5000 | 41876 | 1.9% |
| 7500 | 41849 | 1.9% |
| 2500 | 40258 | 1.8% |
| 4000 | 36396 | 1.6% |
| 8500 | 36350 | 1.6% |
| 3000 | 35597 | 1.6% |
| Other values (10766) | 1825655 |
| Value | Count | Frequency (%) |
| 255 | 1 | < 0.1% |
| 259 | 11 | < 0.1% |
| 260 | 3 | < 0.1% |
| 265 | 2 | < 0.1% |
| 269 | 3 | < 0.1% |
| 270 | 1 | < 0.1% |
| 275 | 28 | |
| 277 | 1 | < 0.1% |
| 279 | 1 | < 0.1% |
| 280 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 74999 | 96 | |
| 74998 | 3 | < 0.1% |
| 74995 | 31 | < 0.1% |
| 74990 | 4 | < 0.1% |
| 74985 | 1 | < 0.1% |
| 74980 | 1 | < 0.1% |
| 74950 | 16 | < 0.1% |
| 74910 | 1 | < 0.1% |
| 74900 | 109 | |
| 74888 | 1 | < 0.1% |
odometer
Real number (ℝ)
High correlation 
| Distinct | 179952 |
|---|---|
| Distinct (%) | 8.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 133436.09 |
| Minimum | 1001 |
|---|---|
| Maximum | 399999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.2 MiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 30500 |
| Q1 | 89594 |
| median | 131000 |
| Q3 | 174000 |
| 95-th percentile | 242423 |
| Maximum | 399999 |
| Range | 398998 |
| Interquartile range (IQR) | 84406 |
Descriptive statistics
| Standard deviation | 63804.414 |
|---|---|
| Coefficient of variation (CV) | 0.4781646 |
| Kurtosis | 0.27203048 |
| Mean | 133436.09 |
| Median Absolute Deviation (MAD) | 42000 |
| Skewness | 0.3823732 |
| Sum | 3.014424 × 1011 |
| Variance | 4.0710032 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 200000 | 36354 | 1.6% |
| 150000 | 29602 | 1.3% |
| 160000 | 26723 | 1.2% |
| 140000 | 25054 | 1.1% |
| 180000 | 24492 | 1.1% |
| 170000 | 23817 | 1.1% |
| 130000 | 23431 | 1.0% |
| 120000 | 21248 | 0.9% |
| 100000 | 18284 | 0.8% |
| 190000 | 17885 | 0.8% |
| Other values (179942) | 2012187 |
| Value | Count | Frequency (%) |
| 1001 | 7 | |
| 1003 | 2 | < 0.1% |
| 1004 | 4 | < 0.1% |
| 1005 | 3 | < 0.1% |
| 1006 | 5 | |
| 1007 | 3 | < 0.1% |
| 1008 | 9 | |
| 1009 | 3 | < 0.1% |
| 1010 | 10 | |
| 1012 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 399999 | 4 | |
| 399990 | 1 | < 0.1% |
| 399896 | 1 | < 0.1% |
| 399842 | 1 | < 0.1% |
| 399788 | 1 | < 0.1% |
| 399700 | 1 | < 0.1% |
| 399699 | 1 | < 0.1% |
| 399695 | 1 | < 0.1% |
| 399600 | 1 | < 0.1% |
| 399559 | 1 | < 0.1% |
year
Real number (ℝ)
High correlation 
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2008.1785 |
| Minimum | 1974 |
|---|---|
| Maximum | 2025 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 17.2 MiB |
Quantile statistics
| Minimum | 1974 |
|---|---|
| 5-th percentile | 1992 |
| Q1 | 2004 |
| median | 2009 |
| Q3 | 2014 |
| 95-th percentile | 2019 |
| Maximum | 2025 |
| Range | 51 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 8.3786356 |
|---|---|
| Coefficient of variation (CV) | 0.0041722565 |
| Kurtosis | 1.9659922 |
| Mean | 2008.1785 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -1.0971392 |
| Sum | 4.5366298 × 109 |
| Variance | 70.201534 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2013 | 128490 | 5.7% |
| 2008 | 126709 | 5.6% |
| 2007 | 125668 | 5.6% |
| 2012 | 124316 | 5.5% |
| 2014 | 118418 | 5.2% |
| 2006 | 116073 | 5.1% |
| 2011 | 113311 | 5.0% |
| 2015 | 108317 | 4.8% |
| 2010 | 102656 | 4.5% |
| 2005 | 100740 | 4.5% |
| Other values (42) | 1094379 |
| Value | Count | Frequency (%) |
| 1974 | 4150 | |
| 1975 | 2907 | |
| 1976 | 4026 | |
| 1977 | 4617 | |
| 1978 | 5163 | |
| 1979 | 5900 | |
| 1980 | 3449 | |
| 1981 | 2926 | |
| 1982 | 3350 | |
| 1983 | 3647 |
| Value | Count | Frequency (%) |
| 2025 | 210 | < 0.1% |
| 2024 | 4681 | 0.2% |
| 2023 | 15470 | 0.7% |
| 2022 | 23264 | 1.0% |
| 2021 | 30892 | 1.4% |
| 2020 | 36598 | 1.6% |
| 2019 | 51901 | |
| 2018 | 63014 | |
| 2017 | 80185 | |
| 2016 | 91738 |
long
Real number (ℝ)
| Distinct | 308101 |
|---|---|
| Distinct (%) | 13.6% |
| Missing | 132 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -100.57771 |
| Minimum | -177.00763 |
|---|---|
| Maximum | 142.12326 |
| Zeros | 2174 |
| Zeros (%) | 0.1% |
| Negative | 2256745 |
| Negative (%) | 99.9% |
| Memory size | 17.2 MiB |
Quantile statistics
| Minimum | -177.00763 |
|---|---|
| 5-th percentile | -122.6801 |
| Q1 | -118.3493 |
| median | -97.8575 |
| Q3 | -80.9167 |
| 95-th percentile | -73.708 |
| Maximum | 142.12326 |
| Range | 319.13089 |
| Interquartile range (IQR) | 37.4326 |
Descriptive statistics
| Standard deviation | 19.957097 |
|---|---|
| Coefficient of variation (CV) | -0.19842466 |
| Kurtosis | -0.10674834 |
| Mean | -100.57771 |
| Median Absolute Deviation (MAD) | 18.4606 |
| Skewness | -0.10943245 |
| Sum | -2.2719951 × 108 |
| Variance | 398.28571 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -80.2926 | 5279 | 0.2% |
| -80.2264 | 4936 | 0.2% |
| -80.1407 | 3817 | 0.2% |
| -80.3165 | 3573 | 0.2% |
| -80.1157 | 3039 | 0.1% |
| -80.403 | 2875 | 0.1% |
| -80.4085 | 2627 | 0.1% |
| -80.1891 | 2573 | 0.1% |
| -80.2153 | 2571 | 0.1% |
| -80.2092 | 2366 | 0.1% |
| Other values (308091) | 2225289 |
| Value | Count | Frequency (%) |
| -177.007631 | 1 | < 0.1% |
| -166.538642 | 1 | < 0.1% |
| -166.1151 | 1 | < 0.1% |
| -165.961268 | 1 | < 0.1% |
| -164.970703 | 1 | < 0.1% |
| -162.7211 | 1 | < 0.1% |
| -162.685547 | 1 | < 0.1% |
| -161.990162 | 3 | |
| -161.8749 | 3 | |
| -159.8251 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 142.12326 | 1 | < 0.1% |
| 139.6917 | 2 | |
| 139.3485 | 1 | < 0.1% |
| 136.8326 | 1 | < 0.1% |
| 128.838981 | 1 | < 0.1% |
| 127.7586 | 2 | |
| 127.0706 | 2 | |
| 126.9775 | 1 | < 0.1% |
| 126.92395 | 4 | |
| 120.5833 | 1 | < 0.1% |
lat
Real number (ℝ)
| Distinct | 308041 |
|---|---|
| Distinct (%) | 13.6% |
| Missing | 132 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.576177 |
| Minimum | -82.921058 |
|---|---|
| Maximum | 142.58258 |
| Zeros | 2179 |
| Zeros (%) | 0.1% |
| Negative | 235 |
| Negative (%) | < 0.1% |
| Memory size | 17.2 MiB |
Quantile statistics
| Minimum | -82.921058 |
|---|---|
| 5-th percentile | 25.98226 |
| Q1 | 33.1098 |
| median | 36.9695 |
| Q3 | 40.9734 |
| 95-th percentile | 46.8829 |
| Maximum | 142.58258 |
| Range | 225.50363 |
| Interquartile range (IQR) | 7.8636 |
Descriptive statistics
| Standard deviation | 6.5373968 |
|---|---|
| Coefficient of variation (CV) | 0.17873374 |
| Kurtosis | 3.1799309 |
| Mean | 36.576177 |
| Median Absolute Deviation (MAD) | 3.9391 |
| Skewness | -0.31992637 |
| Sum | 82623572 |
| Variance | 42.737557 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 25.8301 | 5279 | 0.2% |
| 26.1122 | 4941 | 0.2% |
| 26.0218 | 4158 | 0.2% |
| 25.985 | 3772 | 0.2% |
| 26.2785 | 3040 | 0.1% |
| 26.152 | 2840 | 0.1% |
| 25.6694 | 2627 | 0.1% |
| 25.9894 | 2559 | 0.1% |
| 26.2674 | 2362 | 0.1% |
| 27.3215 | 2225 | 0.1% |
| Other values (308031) | 2225142 |
| Value | Count | Frequency (%) |
| -82.921058 | 1 | |
| -80.172912 | 1 | |
| -77.911331 | 1 | |
| -75.747631 | 1 | |
| -67.980238 | 1 | |
| -66.787821 | 1 | |
| -64.633523 | 1 | |
| -63.477932 | 1 | |
| -62.712724 | 1 | |
| -62.428643 | 1 |
| Value | Count | Frequency (%) |
| 142.582577 | 1 | < 0.1% |
| 71.683788 | 1 | < 0.1% |
| 71.41821 | 1 | < 0.1% |
| 66.742308 | 1 | < 0.1% |
| 66.5656 | 1 | < 0.1% |
| 65.168 | 1 | < 0.1% |
| 65.0907 | 1 | < 0.1% |
| 65.07 | 17 | |
| 65.002647 | 1 | < 0.1% |
| 64.999013 | 1 | < 0.1% |
make
Text
Missing 
| Distinct | 65 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 46488 |
| Missing (%) | 2.1% |
| Memory size | 117.2 MiB |
Length
| Max length | 13 |
|---|---|
| Median length | 11 |
| Mean length | 5.869565 |
| Min length | 3 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | bmw |
|---|---|
| 2nd row | ford |
| 3rd row | buick |
| 4th row | ford |
| 5th row | mini |
| Value | Count | Frequency (%) |
| ford | 338920 | |
| toyota | 257162 | 11.6% |
| chevrolet | 253404 | 11.4% |
| honda | 159476 | 7.2% |
| nissan | 127411 | 5.7% |
| jeep | 91056 | 4.1% |
| bmw | 83121 | 3.7% |
| mercedes-benz | 68322 | 3.1% |
| ram | 67864 | 3.0% |
| gmc | 67864 | 3.0% |
| Other values (58) | 710478 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 1488077 | 11.5% |
| e | 1226277 | 9.4% |
| a | 1110565 | 8.6% |
| r | 967700 | 7.5% |
| t | 850280 | 6.5% |
| d | 847006 | 6.5% |
| n | 726607 | 5.6% |
| s | 611655 | 4.7% |
| c | 586474 | 4.5% |
| h | 532245 | 4.1% |
| Other values (17) | 4040049 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12986935 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 1488077 | 11.5% |
| e | 1226277 | 9.4% |
| a | 1110565 | 8.6% |
| r | 967700 | 7.5% |
| t | 850280 | 6.5% |
| d | 847006 | 6.5% |
| n | 726607 | 5.6% |
| s | 611655 | 4.7% |
| c | 586474 | 4.5% |
| h | 532245 | 4.1% |
| Other values (17) | 4040049 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12986935 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 1488077 | 11.5% |
| e | 1226277 | 9.4% |
| a | 1110565 | 8.6% |
| r | 967700 | 7.5% |
| t | 850280 | 6.5% |
| d | 847006 | 6.5% |
| n | 726607 | 5.6% |
| s | 611655 | 4.7% |
| c | 586474 | 4.5% |
| h | 532245 | 4.1% |
| Other values (17) | 4040049 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12986935 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 1488077 | 11.5% |
| e | 1226277 | 9.4% |
| a | 1110565 | 8.6% |
| r | 967700 | 7.5% |
| t | 850280 | 6.5% |
| d | 847006 | 6.5% |
| n | 726607 | 5.6% |
| s | 611655 | 4.7% |
| c | 586474 | 4.5% |
| h | 532245 | 4.1% |
| Other values (17) | 4040049 |
title
Categorical
Imbalance 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 116.7 MiB |
| clean | |
|---|---|
| rebuilt | 101686 |
| salvage | 76605 |
| lien | 19924 |
| missing | 6626 |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 5.1591291 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | clean |
|---|---|
| 2nd row | clean |
| 3rd row | clean |
| 4th row | clean |
| 5th row | lien |
Common Values
| Value | Count | Frequency (%) |
| clean | 2052321 | |
| rebuilt | 101686 | 4.5% |
| salvage | 76605 | 3.4% |
| lien | 19924 | 0.9% |
| missing | 6626 | 0.3% |
| parts only | 1915 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| clean | 2052321 | |
| rebuilt | 101686 | 4.5% |
| salvage | 76605 | 3.4% |
| lien | 19924 | 0.9% |
| missing | 6626 | 0.3% |
| parts | 1915 | 0.1% |
| only | 1915 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 2252451 | |
| e | 2250536 | |
| a | 2207446 | |
| n | 2080786 | |
| c | 2052321 | |
| i | 134862 | 1.2% |
| t | 103601 | 0.9% |
| r | 103601 | 0.9% |
| u | 101686 | 0.9% |
| b | 101686 | 0.9% |
| Other values (8) | 265894 | 2.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11654870 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 2252451 | |
| e | 2250536 | |
| a | 2207446 | |
| n | 2080786 | |
| c | 2052321 | |
| i | 134862 | 1.2% |
| t | 103601 | 0.9% |
| r | 103601 | 0.9% |
| u | 101686 | 0.9% |
| b | 101686 | 0.9% |
| Other values (8) | 265894 | 2.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11654870 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 2252451 | |
| e | 2250536 | |
| a | 2207446 | |
| n | 2080786 | |
| c | 2052321 | |
| i | 134862 | 1.2% |
| t | 103601 | 0.9% |
| r | 103601 | 0.9% |
| u | 101686 | 0.9% |
| b | 101686 | 0.9% |
| Other values (8) | 265894 | 2.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11654870 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 2252451 | |
| e | 2250536 | |
| a | 2207446 | |
| n | 2080786 | |
| c | 2052321 | |
| i | 134862 | 1.2% |
| t | 103601 | 0.9% |
| r | 103601 | 0.9% |
| u | 101686 | 0.9% |
| b | 101686 | 0.9% |
| Other values (8) | 265894 | 2.3% |
predicted_price
Real number (ℝ)
High correlation  Missing 
| Distinct | 880257 |
|---|---|
| Distinct (%) | 52.1% |
| Missing | 568801 |
| Missing (%) | 25.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9654.2327 |
| Minimum | -130010.67 |
|---|---|
| Maximum | 199744.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 32469 |
| Negative (%) | 1.4% |
| Memory size | 17.2 MiB |
Quantile statistics
| Minimum | -130010.67 |
|---|---|
| 5-th percentile | 1323.6216 |
| Q1 | 3984.4621 |
| median | 6970.3885 |
| Q3 | 12147.898 |
| 95-th percentile | 27928.542 |
| Maximum | 199744.8 |
| Range | 329755.47 |
| Interquartile range (IQR) | 8163.4361 |
Descriptive statistics
| Standard deviation | 9229.3266 |
|---|---|
| Coefficient of variation (CV) | 0.95598759 |
| Kurtosis | 10.463864 |
| Mean | 9654.2327 |
| Median Absolute Deviation (MAD) | 3592.1458 |
| Skewness | 2.5012176 |
| Sum | 1.6318318 × 1010 |
| Variance | 85180470 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5902.958331 | 360 | < 0.1% |
| 13114.58296 | 310 | < 0.1% |
| 5252.8994 | 310 | < 0.1% |
| 5639.426842 | 210 | < 0.1% |
| 4997.341533 | 185 | < 0.1% |
| 7498.932142 | 169 | < 0.1% |
| 28448.35148 | 160 | < 0.1% |
| 16001.02651 | 153 | < 0.1% |
| 6506.118276 | 145 | < 0.1% |
| 33370.6295 | 141 | < 0.1% |
| Other values (880247) | 1688133 | |
| (Missing) | 568801 | 25.2% |
| Value | Count | Frequency (%) |
| -130010.6665 | 1 | < 0.1% |
| -126408.7028 | 1 | < 0.1% |
| -112889.5666 | 2 | < 0.1% |
| -84341.24129 | 1 | < 0.1% |
| -82038.97127 | 1 | < 0.1% |
| -81208.26793 | 1 | < 0.1% |
| -76723.25057 | 5 | |
| -65224.41556 | 1 | < 0.1% |
| -64493.15741 | 1 | < 0.1% |
| -63327.52873 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 199744.8004 | 1 | |
| 185005.8282 | 1 | |
| 162719.2224 | 1 | |
| 154389.4149 | 1 | |
| 149271.8248 | 1 | |
| 143567.4825 | 1 | |
| 140640.0716 | 1 | |
| 138479.5499 | 1 | |
| 132867.4969 | 1 | |
| 131402.7434 | 1 |
residual
Real number (ℝ)
Missing 
| Distinct | 1241173 |
|---|---|
| Distinct (%) | 73.4% |
| Missing | 568801 |
| Missing (%) | 25.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 921.42951 |
| Minimum | -198054.8 |
|---|---|
| Maximum | 147708.27 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 693904 |
| Negative (%) | 30.7% |
| Memory size | 17.2 MiB |
Quantile statistics
| Minimum | -198054.8 |
|---|---|
| 5-th percentile | -5661.2037 |
| Q1 | -1129.7161 |
| median | 536.63518 |
| Q3 | 2468.2644 |
| 95-th percentile | 9074.0227 |
| Maximum | 147708.27 |
| Range | 345763.07 |
| Interquartile range (IQR) | 3597.9805 |
Descriptive statistics
| Standard deviation | 5462.0434 |
|---|---|
| Coefficient of variation (CV) | 5.927793 |
| Kurtosis | 24.403018 |
| Mean | 921.42951 |
| Median Absolute Deviation (MAD) | 1783.7305 |
| Skewness | 0.62787115 |
| Sum | 1.5574702 × 109 |
| Variance | 29833918 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 15385.41704 | 306 | < 0.1% |
| 587.0416687 | 170 | < 0.1% |
| 47.10060034 | 165 | < 0.1% |
| 1401.067858 | 165 | < 0.1% |
| 898.9734885 | 150 | < 0.1% |
| -13483.06932 | 140 | < 0.1% |
| -476.7844254 | 135 | < 0.1% |
| 1939.803574 | 132 | < 0.1% |
| -7814.969437 | 125 | < 0.1% |
| 346.788378 | 125 | < 0.1% |
| Other values (1241163) | 1688663 | |
| (Missing) | 568801 | 25.2% |
| Value | Count | Frequency (%) |
| -198054.8004 | 1 | |
| -183505.8282 | 1 | |
| -161029.2224 | 1 | |
| -129867.4969 | 1 | |
| -116675.5318 | 1 | |
| -115695.425 | 1 | |
| -113567.4825 | 1 | |
| -99209.1648 | 1 | |
| -97829.47848 | 1 | |
| -97167.04486 | 1 |
| Value | Count | Frequency (%) |
| 147708.2679 | 1 | < 0.1% |
| 133308.7028 | 1 | < 0.1% |
| 132010.6665 | 1 | < 0.1% |
| 127889.5666 | 2 | < 0.1% |
| 113223.2506 | 5 | |
| 99538.97127 | 1 | < 0.1% |
| 96841.24129 | 1 | < 0.1% |
| 93293.15741 | 1 | < 0.1% |
| 93001.32433 | 1 | < 0.1% |
| 89346.94801 | 1 | < 0.1% |
time_posted
Date
| Distinct | 1831229 |
|---|---|
| Distinct (%) | 81.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 17.2 MiB |
| Minimum | 2023-11-18 08:00:36+00:00 |
|---|---|
| Maximum | 2024-11-16 17:07:29+00:00 |
condition
Categorical
Missing 
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 364408 |
| Missing (%) | 16.1% |
| Memory size | 119.9 MiB |
| excellent | |
|---|---|
| good | |
| like new | |
| fair | |
| salvage | 13168 |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 6.5912072 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | excellent |
|---|---|
| 2nd row | good |
| 3rd row | good |
| 4th row | good |
| 5th row | good |
Common Values
| Value | Count | Frequency (%) |
| excellent | 793640 | |
| good | 705423 | |
| like new | 228300 | 10.1% |
| fair | 142714 | 6.3% |
| salvage | 13168 | 0.6% |
| new | 11424 | 0.5% |
| (Missing) | 364408 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| excellent | 793640 | |
| good | 705423 | |
| new | 239724 | 11.3% |
| like | 228300 | 10.8% |
| fair | 142714 | 6.7% |
| salvage | 13168 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2862112 | |
| l | 1828748 | |
| o | 1410846 | |
| n | 1033364 | 8.3% |
| x | 793640 | 6.4% |
| c | 793640 | 6.4% |
| t | 793640 | 6.4% |
| g | 718591 | 5.8% |
| d | 705423 | 5.6% |
| i | 371014 | 3.0% |
| Other values (8) | 1177138 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12488156 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 2862112 | |
| l | 1828748 | |
| o | 1410846 | |
| n | 1033364 | 8.3% |
| x | 793640 | 6.4% |
| c | 793640 | 6.4% |
| t | 793640 | 6.4% |
| g | 718591 | 5.8% |
| d | 705423 | 5.6% |
| i | 371014 | 3.0% |
| Other values (8) | 1177138 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12488156 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 2862112 | |
| l | 1828748 | |
| o | 1410846 | |
| n | 1033364 | 8.3% |
| x | 793640 | 6.4% |
| c | 793640 | 6.4% |
| t | 793640 | 6.4% |
| g | 718591 | 5.8% |
| d | 705423 | 5.6% |
| i | 371014 | 3.0% |
| Other values (8) | 1177138 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12488156 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 2862112 | |
| l | 1828748 | |
| o | 1410846 | |
| n | 1033364 | 8.3% |
| x | 793640 | 6.4% |
| c | 793640 | 6.4% |
| t | 793640 | 6.4% |
| g | 718591 | 5.8% |
| d | 705423 | 5.6% |
| i | 371014 | 3.0% |
| Other values (8) | 1177138 |
url
URL
| Distinct | 1969478 |
|---|---|
| Distinct (%) | 87.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 293.3 MiB |
| https://miami.craigslist.org/mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html | 110 |
|---|---|
| https://miami.craigslist.org/pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html | 95 |
| https://miami.craigslist.org/pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html | 95 |
| https://miami.craigslist.org/pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html | 95 |
| https://miami.craigslist.org/mdc/cto/d/miami-2005-lexus-ls430/7761198368.html | 90 |
| Other values (1969473) |
| Value | Count | Frequency (%) |
| https://miami.craigslist.org/mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html | 110 | < 0.1% |
| https://miami.craigslist.org/pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html | 95 | < 0.1% |
| https://miami.craigslist.org/pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html | 95 | < 0.1% |
| https://miami.craigslist.org/pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html | 95 | < 0.1% |
| https://miami.craigslist.org/mdc/cto/d/miami-2005-lexus-ls430/7761198368.html | 90 | < 0.1% |
| https://miami.craigslist.org/mdc/cto/d/miami-2011-ford-mustang/7760134705.html | 90 | < 0.1% |
| https://miami.craigslist.org/pbc/cto/d/lake-worth-2004-bmw-325i-ice-cold-ac/7754977134.html | 85 | < 0.1% |
| https://miami.craigslist.org/brw/cto/d/fort-lauderdale-lexus-ct200h-2015/7759810242.html | 85 | < 0.1% |
| https://miami.craigslist.org/mdc/cto/d/miami-2019-gmc-acadia/7760605245.html | 85 | < 0.1% |
| https://miami.craigslist.org/mdc/cto/d/hallandale-hyundai-sonata-2017/7755236994.html | 80 | < 0.1% |
| Other values (1969468) | 2258167 |
| Value | Count | Frequency (%) |
| https | 2259077 |
| Value | Count | Frequency (%) |
| miami.craigslist.org | 201461 | 8.9% |
| sfbay.craigslist.org | 140662 | 6.2% |
| losangeles.craigslist.org | 103127 | 4.6% |
| phoenix.craigslist.org | 91298 | 4.0% |
| portland.craigslist.org | 65051 | 2.9% |
| seattle.craigslist.org | 64930 | 2.9% |
| sandiego.craigslist.org | 60529 | 2.7% |
| sacramento.craigslist.org | 56347 | 2.5% |
| orangecounty.craigslist.org | 51072 | 2.3% |
| dallas.craigslist.org | 48093 | 2.1% |
| Other values (405) | 1376507 |
| Value | Count | Frequency (%) |
| /mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html | 110 | < 0.1% |
| /pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html | 95 | < 0.1% |
| /pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html | 95 | < 0.1% |
| /pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html | 95 | < 0.1% |
| /mdc/cto/d/miami-2005-lexus-ls430/7761198368.html | 90 | < 0.1% |
| /mdc/cto/d/miami-2011-ford-mustang/7760134705.html | 90 | < 0.1% |
| /pbc/cto/d/lake-worth-2004-bmw-325i-ice-cold-ac/7754977134.html | 85 | < 0.1% |
| /brw/cto/d/fort-lauderdale-lexus-ct200h-2015/7759810242.html | 85 | < 0.1% |
| /mdc/cto/d/miami-2019-gmc-acadia/7760605245.html | 85 | < 0.1% |
| /mdc/cto/d/hallandale-hyundai-sonata-2017/7755236994.html | 80 | < 0.1% |
| Other values (1969468) | 2258167 |
| Value | Count | Frequency (%) |
| 2259077 |
| Value | Count | Frequency (%) |
| 2259077 |
state
Text
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 123.8 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 14 |
| Mean length | 8.4474168 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | California |
|---|---|
| 2nd row | Arizona |
| 3rd row | California |
| 4th row | Florida |
| 5th row | Wisconsin |
| Value | Count | Frequency (%) |
| california | 534433 | |
| florida | 291973 | 11.4% |
| new | 174426 | 6.8% |
| texas | 150205 | 5.9% |
| arizona | 126315 | 4.9% |
| washington | 103465 | 4.1% |
| oregon | 101656 | 4.0% |
| york | 93579 | 3.7% |
| colorado | 75793 | 3.0% |
| carolina | 58960 | 2.3% |
| Other values (45) | 842407 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2646665 | |
| i | 2379989 | |
| o | 1982513 | |
| n | 1561889 | 8.2% |
| r | 1531112 | 8.0% |
| l | 1156653 | 6.1% |
| e | 889622 | 4.7% |
| s | 792355 | 4.2% |
| C | 708142 | 3.7% |
| f | 557168 | 2.9% |
| Other values (36) | 4877257 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 19083365 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2646665 | |
| i | 2379989 | |
| o | 1982513 | |
| n | 1561889 | 8.2% |
| r | 1531112 | 8.0% |
| l | 1156653 | 6.1% |
| e | 889622 | 4.7% |
| s | 792355 | 4.2% |
| C | 708142 | 3.7% |
| f | 557168 | 2.9% |
| Other values (36) | 4877257 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 19083365 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2646665 | |
| i | 2379989 | |
| o | 1982513 | |
| n | 1561889 | 8.2% |
| r | 1531112 | 8.0% |
| l | 1156653 | 6.1% |
| e | 889622 | 4.7% |
| s | 792355 | 4.2% |
| C | 708142 | 3.7% |
| f | 557168 | 2.9% |
| Other values (36) | 4877257 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 19083365 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2646665 | |
| i | 2379989 | |
| o | 1982513 | |
| n | 1561889 | 8.2% |
| r | 1531112 | 8.0% |
| l | 1156653 | 6.1% |
| e | 889622 | 4.7% |
| s | 792355 | 4.2% |
| C | 708142 | 3.7% |
| f | 557168 | 2.9% |
| Other values (36) | 4877257 |
model
Text
Missing 
| Distinct | 1283 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 190148 |
| Missing (%) | 8.4% |
| Memory size | 113.6 MiB |
Length
| Max length | 31 |
|---|---|
| Median length | 26 |
| Mean length | 5.6330942 |
| Min length | 1 |
Unique
| Unique | 69 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | x1 |
|---|---|
| 2nd row | excursion |
| 3rd row | verano |
| 4th row | e350 |
| 5th row | clubman |
| Value | Count | Frequency (%) |
| 1500 | 71162 | 3.2% |
| f150 | 67969 | 3.0% |
| silverado | 52885 | 2.4% |
| camry | 44876 | 2.0% |
| accord | 44177 | 2.0% |
| r | 41027 | 1.8% |
| 2500 | 40682 | 1.8% |
| civic | 39144 | 1.8% |
| wrangler | 37629 | 1.7% |
| f250 | 31463 | 1.4% |
| Other values (940) | 1764330 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 1181512 | 10.1% |
| r | 1147741 | 9.8% |
| e | 1011281 | 8.7% |
| o | 730789 | 6.3% |
| c | 674533 | 5.8% |
| t | 601475 | 5.2% |
| s | 592841 | 5.1% |
| i | 563196 | 4.8% |
| n | 553343 | 4.7% |
| 0 | 505374 | 4.3% |
| Other values (31) | 4092387 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 11654472 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 1181512 | 10.1% |
| r | 1147741 | 9.8% |
| e | 1011281 | 8.7% |
| o | 730789 | 6.3% |
| c | 674533 | 5.8% |
| t | 601475 | 5.2% |
| s | 592841 | 5.1% |
| i | 563196 | 4.8% |
| n | 553343 | 4.7% |
| 0 | 505374 | 4.3% |
| Other values (31) | 4092387 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 11654472 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 1181512 | 10.1% |
| r | 1147741 | 9.8% |
| e | 1011281 | 8.7% |
| o | 730789 | 6.3% |
| c | 674533 | 5.8% |
| t | 601475 | 5.2% |
| s | 592841 | 5.1% |
| i | 563196 | 4.8% |
| n | 553343 | 4.7% |
| 0 | 505374 | 4.3% |
| Other values (31) | 4092387 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 11654472 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 1181512 | 10.1% |
| r | 1147741 | 9.8% |
| e | 1011281 | 8.7% |
| o | 730789 | 6.3% |
| c | 674533 | 5.8% |
| t | 601475 | 5.2% |
| s | 592841 | 5.1% |
| i | 563196 | 4.8% |
| n | 553343 | 4.7% |
| 0 | 505374 | 4.3% |
| Other values (31) | 4092387 |
paint
Categorical
Missing 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 614472 |
| Missing (%) | 27.2% |
| Memory size | 117.1 MiB |
| white | |
|---|---|
| black | |
| silver | |
| grey | |
| blue | |
| Other values (7) |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 4.7564023 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | white |
|---|---|
| 2nd row | black |
| 3rd row | white |
| 4th row | white |
| 5th row | green |
Common Values
| Value | Count | Frequency (%) |
| white | 403912 | |
| black | 286518 | |
| silver | 235085 | 10.4% |
| grey | 213031 | 9.4% |
| blue | 177369 | 7.9% |
| red | 155680 | 6.9% |
| green | 59294 | 2.6% |
| brown | 47663 | 2.1% |
| custom | 35842 | 1.6% |
| yellow | 14956 | 0.7% |
| Other values (2) | 15255 | 0.7% |
| (Missing) | 614472 |
Length
| Value | Count | Frequency (%) |
| white | 403912 | |
| black | 286518 | |
| silver | 235085 | |
| grey | 213031 | |
| blue | 177369 | |
| red | 155680 | 9.5% |
| green | 59294 | 3.6% |
| brown | 47663 | 2.9% |
| custom | 35842 | 2.2% |
| yellow | 14956 | 0.9% |
| Other values (2) | 15255 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1333876 | |
| l | 734675 | 9.4% |
| r | 726008 | 9.3% |
| i | 638997 | 8.2% |
| b | 511550 | 6.5% |
| w | 466531 | 6.0% |
| t | 439754 | 5.6% |
| h | 403912 | 5.2% |
| c | 322360 | 4.1% |
| a | 295982 | 3.8% |
| Other values (11) | 1948758 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7822403 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1333876 | |
| l | 734675 | 9.4% |
| r | 726008 | 9.3% |
| i | 638997 | 8.2% |
| b | 511550 | 6.5% |
| w | 466531 | 6.0% |
| t | 439754 | 5.6% |
| h | 403912 | 5.2% |
| c | 322360 | 4.1% |
| a | 295982 | 3.8% |
| Other values (11) | 1948758 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7822403 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1333876 | |
| l | 734675 | 9.4% |
| r | 726008 | 9.3% |
| i | 638997 | 8.2% |
| b | 511550 | 6.5% |
| w | 466531 | 6.0% |
| t | 439754 | 5.6% |
| h | 403912 | 5.2% |
| c | 322360 | 4.1% |
| a | 295982 | 3.8% |
| Other values (11) | 1948758 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7822403 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1333876 | |
| l | 734675 | 9.4% |
| r | 726008 | 9.3% |
| i | 638997 | 8.2% |
| b | 511550 | 6.5% |
| w | 466531 | 6.0% |
| t | 439754 | 5.6% |
| h | 403912 | 5.2% |
| c | 322360 | 4.1% |
| a | 295982 | 3.8% |
| Other values (11) | 1948758 |
fuel
Categorical
Imbalance 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9 |
| Missing (%) | < 0.1% |
| Memory size | 112.6 MiB |
| gas | |
|---|---|
| diesel | 128318 |
| hybrid | 49622 |
| electric | 20677 |
| other | 5490 |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 3.2869258 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | gas |
|---|---|
| 2nd row | gas |
| 3rd row | gas |
| 4th row | diesel |
| 5th row | gas |
Common Values
| Value | Count | Frequency (%) |
| gas | 2054961 | |
| diesel | 128318 | 5.7% |
| hybrid | 49622 | 2.2% |
| electric | 20677 | 0.9% |
| other | 5490 | 0.2% |
| (Missing) | 9 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| gas | 2054961 | |
| diesel | 128318 | 5.7% |
| hybrid | 49622 | 2.2% |
| electric | 20677 | 0.9% |
| other | 5490 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 2183279 | |
| g | 2054961 | |
| a | 2054961 | |
| e | 303480 | 4.1% |
| i | 198617 | 2.7% |
| d | 177940 | 2.4% |
| l | 148995 | 2.0% |
| r | 75789 | 1.0% |
| h | 55112 | 0.7% |
| y | 49622 | 0.7% |
| Other values (4) | 122633 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7425389 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 2183279 | |
| g | 2054961 | |
| a | 2054961 | |
| e | 303480 | 4.1% |
| i | 198617 | 2.7% |
| d | 177940 | 2.4% |
| l | 148995 | 2.0% |
| r | 75789 | 1.0% |
| h | 55112 | 0.7% |
| y | 49622 | 0.7% |
| Other values (4) | 122633 | 1.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7425389 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 2183279 | |
| g | 2054961 | |
| a | 2054961 | |
| e | 303480 | 4.1% |
| i | 198617 | 2.7% |
| d | 177940 | 2.4% |
| l | 148995 | 2.0% |
| r | 75789 | 1.0% |
| h | 55112 | 0.7% |
| y | 49622 | 0.7% |
| Other values (4) | 122633 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7425389 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 2183279 | |
| g | 2054961 | |
| a | 2054961 | |
| e | 303480 | 4.1% |
| i | 198617 | 2.7% |
| d | 177940 | 2.4% |
| l | 148995 | 2.0% |
| r | 75789 | 1.0% |
| h | 55112 | 0.7% |
| y | 49622 | 0.7% |
| Other values (4) | 122633 | 1.7% |
drive
Categorical
High correlation  Missing 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 663908 |
| Missing (%) | 29.4% |
| Memory size | 114.6 MiB |
| 4wd | |
|---|---|
| fwd | |
| rwd |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | fwd |
|---|---|
| 2nd row | 4wd |
| 3rd row | fwd |
| 4th row | rwd |
| 5th row | fwd |
Common Values
| Value | Count | Frequency (%) |
| 4wd | 634934 | |
| fwd | 564101 | |
| rwd | 396134 | |
| (Missing) | 663908 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4wd | 634934 | |
| fwd | 564101 | |
| rwd | 396134 |
Most occurring characters
| Value | Count | Frequency (%) |
| w | 1595169 | |
| d | 1595169 | |
| 4 | 634934 | 13.3% |
| f | 564101 | 11.8% |
| r | 396134 | 8.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4785507 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| w | 1595169 | |
| d | 1595169 | |
| 4 | 634934 | 13.3% |
| f | 564101 | 11.8% |
| r | 396134 | 8.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4785507 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| w | 1595169 | |
| d | 1595169 | |
| 4 | 634934 | 13.3% |
| f | 564101 | 11.8% |
| r | 396134 | 8.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4785507 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| w | 1595169 | |
| d | 1595169 | |
| 4 | 634934 | 13.3% |
| f | 564101 | 11.8% |
| r | 396134 | 8.3% |
type
Categorical
High correlation  Missing 
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 444260 |
| Missing (%) | 19.7% |
| Memory size | 117.2 MiB |
| sedan | |
|---|---|
| SUV | |
| pickup | |
| truck | |
| coupe | |
| Other values (9) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 5.0283345 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SUV |
|---|---|
| 2nd row | sedan |
| 3rd row | van |
| 4th row | wagon |
| 5th row | hatchback |
Common Values
| Value | Count | Frequency (%) |
| sedan | 490546 | |
| SUV | 489445 | |
| pickup | 227602 | |
| truck | 151324 | 6.7% |
| coupe | 100198 | 4.4% |
| hatchback | 98399 | 4.4% |
| convertible | 71424 | 3.2% |
| van | 69050 | 3.1% |
| minivan | 46538 | 2.1% |
| wagon | 33142 | 1.5% |
| Other values (4) | 37149 | 1.6% |
| (Missing) | 444260 |
Length
| Value | Count | Frequency (%) |
| sedan | 490546 | |
| suv | 489445 | |
| pickup | 227602 | |
| truck | 151324 | 8.3% |
| coupe | 100198 | 5.5% |
| hatchback | 98399 | 5.4% |
| convertible | 71424 | 3.9% |
| van | 69050 | 3.8% |
| minivan | 46538 | 2.6% |
| wagon | 33142 | 1.8% |
| Other values (4) | 37149 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 850346 | 9.3% |
| n | 767742 | 8.4% |
| e | 752368 | 8.2% |
| c | 747346 | 8.2% |
| p | 555402 | 6.1% |
| d | 499566 | 5.5% |
| s | 494647 | 5.4% |
| S | 489445 | 5.4% |
| U | 489445 | 5.4% |
| V | 489445 | 5.4% |
| Other values (15) | 2989755 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9125507 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 850346 | 9.3% |
| n | 767742 | 8.4% |
| e | 752368 | 8.2% |
| c | 747346 | 8.2% |
| p | 555402 | 6.1% |
| d | 499566 | 5.5% |
| s | 494647 | 5.4% |
| S | 489445 | 5.4% |
| U | 489445 | 5.4% |
| V | 489445 | 5.4% |
| Other values (15) | 2989755 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9125507 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 850346 | 9.3% |
| n | 767742 | 8.4% |
| e | 752368 | 8.2% |
| c | 747346 | 8.2% |
| p | 555402 | 6.1% |
| d | 499566 | 5.5% |
| s | 494647 | 5.4% |
| S | 489445 | 5.4% |
| U | 489445 | 5.4% |
| V | 489445 | 5.4% |
| Other values (15) | 2989755 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9125507 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 850346 | 9.3% |
| n | 767742 | 8.4% |
| e | 752368 | 8.2% |
| c | 747346 | 8.2% |
| p | 555402 | 6.1% |
| d | 499566 | 5.5% |
| s | 494647 | 5.4% |
| S | 489445 | 5.4% |
| U | 489445 | 5.4% |
| V | 489445 | 5.4% |
| Other values (15) | 2989755 |
transmission
Categorical
Imbalance 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 124.3 MiB |
| automatic | |
|---|---|
| manual | |
| other | 14387 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.6857137 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | automatic |
|---|---|
| 2nd row | automatic |
| 3rd row | automatic |
| 4th row | automatic |
| 5th row | manual |
Common Values
| Value | Count | Frequency (%) |
| automatic | 2027207 | |
| manual | 217483 | 9.6% |
| other | 14387 | 0.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| automatic | 2027207 | |
| manual | 217483 | 9.6% |
| other | 14387 | 0.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4489380 | |
| t | 4068801 | |
| u | 2244690 | |
| m | 2244690 | |
| o | 2041594 | |
| i | 2027207 | |
| c | 2027207 | |
| n | 217483 | 1.1% |
| l | 217483 | 1.1% |
| h | 14387 | 0.1% |
| Other values (2) | 28774 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 19621696 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 4489380 | |
| t | 4068801 | |
| u | 2244690 | |
| m | 2244690 | |
| o | 2041594 | |
| i | 2027207 | |
| c | 2027207 | |
| n | 217483 | 1.1% |
| l | 217483 | 1.1% |
| h | 14387 | 0.1% |
| Other values (2) | 28774 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 19621696 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 4489380 | |
| t | 4068801 | |
| u | 2244690 | |
| m | 2244690 | |
| o | 2041594 | |
| i | 2027207 | |
| c | 2027207 | |
| n | 217483 | 1.1% |
| l | 217483 | 1.1% |
| h | 14387 | 0.1% |
| Other values (2) | 28774 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 19621696 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 4489380 | |
| t | 4068801 | |
| u | 2244690 | |
| m | 2244690 | |
| o | 2041594 | |
| i | 2027207 | |
| c | 2027207 | |
| n | 217483 | 1.1% |
| l | 217483 | 1.1% |
| h | 14387 | 0.1% |
| Other values (2) | 28774 | 0.1% |
Interactions
Correlations
| condition | drive | fuel | lat | long | odometer | paint | predicted_price | price | residual | title | transmission | type | year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| condition | 1.000 | 0.015 | 0.046 | 0.042 | 0.029 | 0.207 | 0.037 | 0.168 | 0.200 | 0.050 | 0.107 | 0.048 | 0.054 | 0.197 |
| drive | 0.015 | 1.000 | 0.139 | 0.097 | 0.038 | 0.089 | 0.104 | 0.087 | 0.195 | 0.101 | 0.057 | 0.073 | 0.515 | 0.207 |
| fuel | 0.046 | 0.139 | 1.000 | 0.019 | 0.046 | 0.121 | 0.069 | 0.071 | 0.149 | 0.120 | 0.026 | 0.176 | 0.242 | 0.109 |
| lat | 0.042 | 0.097 | 0.019 | 1.000 | -0.124 | 0.064 | 0.012 | -0.068 | -0.032 | 0.089 | 0.052 | 0.028 | 0.025 | -0.102 |
| long | 0.029 | 0.038 | 0.046 | -0.124 | 1.000 | -0.008 | 0.028 | -0.004 | -0.070 | -0.134 | 0.063 | 0.028 | 0.045 | 0.073 |
| odometer | 0.207 | 0.089 | 0.121 | 0.064 | -0.008 | 1.000 | 0.036 | -0.615 | -0.505 | 0.077 | 0.079 | 0.054 | 0.088 | -0.376 |
| paint | 0.037 | 0.104 | 0.069 | 0.012 | 0.028 | 0.036 | 1.000 | 0.035 | 0.049 | 0.020 | 0.023 | 0.081 | 0.098 | 0.105 |
| predicted_price | 0.168 | 0.087 | 0.071 | -0.068 | -0.004 | -0.615 | 0.035 | 1.000 | 0.820 | -0.160 | 0.044 | 0.044 | 0.050 | 0.577 |
| price | 0.200 | 0.195 | 0.149 | -0.032 | -0.070 | -0.505 | 0.049 | 0.820 | 1.000 | 0.323 | 0.072 | 0.029 | 0.097 | 0.477 |
| residual | 0.050 | 0.101 | 0.120 | 0.089 | -0.134 | 0.077 | 0.020 | -0.160 | 0.323 | 1.000 | 0.035 | 0.040 | 0.060 | -0.033 |
| title | 0.107 | 0.057 | 0.026 | 0.052 | 0.063 | 0.079 | 0.023 | 0.044 | 0.072 | 0.035 | 1.000 | 0.034 | 0.040 | 0.103 |
| transmission | 0.048 | 0.073 | 0.176 | 0.028 | 0.028 | 0.054 | 0.081 | 0.044 | 0.029 | 0.040 | 0.034 | 1.000 | 0.193 | 0.197 |
| type | 0.054 | 0.515 | 0.242 | 0.025 | 0.045 | 0.088 | 0.098 | 0.050 | 0.097 | 0.060 | 0.040 | 0.193 | 1.000 | 0.113 |
| year | 0.197 | 0.207 | 0.109 | -0.102 | 0.073 | -0.376 | 0.105 | 0.577 | 0.477 | -0.033 | 0.103 | 0.197 | 0.113 | 1.000 |
Missing values
Sample
| location | price | odometer | year | long | lat | make | title | predicted_price | residual | time_posted | condition | url | state | model | paint | fuel | drive | type | transmission | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | sfbay | 8000.0 | 107000.0 | 2014.0 | -122.2635 | 37.5364 | bmw | clean | 9149.465612 | -1149.465612 | 2024-11-14 08:40:06+00:00 | excellent | https://sfbay.craigslist.org/pen/cto/d/redwood-city-bmw-x1-2014/7802085178.html | California | x1 | white | gas | fwd | SUV | automatic |
| 1 | phoenix | 11900.0 | 212000.0 | 2000.0 | -111.9198 | 33.3092 | ford | clean | 5604.272149 | 6295.727851 | 2024-11-13 06:31:08+00:00 | good | https://phoenix.craigslist.org/wvl/cto/d/tempe-ford-excursion/7801735227.html | Arizona | excursion | black | gas | 4wd | None | automatic |
| 2 | sandiego | 9800.0 | 58000.0 | 2014.0 | -117.0978 | 33.1605 | buick | clean | 5590.210883 | 4209.789117 | 2024-11-10 19:25:57+00:00 | good | https://sandiego.craigslist.org/nsd/cto/d/escondido-2014-buick-verano-turbo/7801080470.html | California | verano | white | gas | fwd | sedan | automatic |
| 3 | miami | 18500.0 | 49500.0 | 2010.0 | -80.0928 | 26.4116 | ford | clean | 13353.856625 | 5146.143375 | 2024-10-28 11:01:13+00:00 | good | https://miami.craigslist.org/pbc/cto/d/boca-raton-ford-diesel-heavy-duty-only/7797221853.html | Florida | e350 | white | diesel | rwd | van | automatic |
| 4 | janesville | 6500.0 | 97000.0 | 2016.0 | -88.9980 | 42.6969 | mini | lien | 7159.862329 | -659.862329 | 2024-10-26 22:00:00+00:00 | good | https://janesville.craigslist.org/cto/d/janesville-2016-mini-cooper-clubman/7796901812.html | Wisconsin | clubman | green | gas | fwd | wagon | manual |
| 5 | palmsprings | 4250.0 | 153800.0 | 2009.0 | -116.5347 | 33.8414 | scion | clean | 4544.302114 | -294.302114 | 2024-10-25 08:01:50+00:00 | excellent | https://palmsprings.craigslist.org/cto/d/palm-springs-2009-scion-xd-silver/7796418026.html | California | xd | silver | gas | fwd | hatchback | automatic |
| 6 | dallas | 4800.0 | 150000.0 | 2015.0 | -96.7955 | 32.7086 | jeep | clean | 5630.785633 | -830.785633 | 2024-10-23 16:45:23+00:00 | like new | https://dallas.craigslist.org/dal/cto/d/dallas-2015-jeep-patriot-runs-great/7795969760.html | Texas | patriot | None | gas | None | SUV | automatic |
| 7 | lubbock | 5700.0 | 100000.0 | 2013.0 | -101.8333 | 33.5260 | nissan | clean | 8659.426468 | -2959.426468 | 2024-10-23 16:07:58+00:00 | excellent | https://lubbock.craigslist.org/cto/d/lubbock-2013-nissan-murano-low-100k/7795958166.html | Texas | murano | white | gas | None | SUV | automatic |
| 8 | orangecounty | 5999.0 | 147000.0 | 2017.0 | -117.8298 | 33.6829 | dodge | clean | 6941.637505 | -942.637505 | 2024-10-12 08:02:38+00:00 | excellent | https://orangecounty.craigslist.org/cto/d/irvine-2017-dodge-journey-se/7792718372.html | California | journey | white | gas | fwd | SUV | automatic |
| 9 | pittsburgh | 2300.0 | 85009.0 | 2005.0 | -80.0876 | 40.4717 | chrysler | clean | 3588.751782 | -1288.751782 | 2024-10-04 12:48:11+00:00 | excellent | https://pittsburgh.craigslist.org/cto/d/mc-kees-rocks-2006-chrysler-pt-cruiser/7790500366.html | Pennsylvania | pt cruiser | silver | gas | fwd | convertible | manual |
| location | price | odometer | year | long | lat | make | title | predicted_price | residual | time_posted | condition | url | state | model | paint | fuel | drive | type | transmission | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2259067 | orangecounty | 21500.0 | 45500.0 | 2013.0 | -117.786500 | 33.905800 | chevrolet | clean | 24249.860163 | -2749.860163 | 2023-12-12 10:55:34+00:00 | like new | https://orangecounty.craigslist.org/cto/d/yorba-linda-2013-chevrolet-silverado/7697086462.html | California | silverado 1500 | silver | gas | rwd | truck | automatic |
| 2259068 | chicago | 3500.0 | 98452.0 | 2002.0 | -87.614250 | 41.672789 | chevrolet | clean | 7545.087024 | -4045.087024 | 2024-09-12 10:51:11+00:00 | good | https://chicago.craigslist.org/chc/cto/d/chicago-2002-chevrolet-1500/7784113491.html | Illinois | silverado 1500 | None | gas | rwd | None | automatic |
| 2259069 | visalia | 18500.0 | 70000.0 | 2009.0 | -119.031500 | 36.068600 | chevrolet | clean | 17445.491959 | 1054.508041 | 2024-03-24 13:51:00+00:00 | excellent | https://visalia.craigslist.org/cto/d/porterville-2009-silverado-1500-lt/7730470178.html | California | silverado 1500 | white | gas | rwd | truck | automatic |
| 2259070 | bellingham | 2800.0 | 196000.0 | 1993.0 | -122.927800 | 48.611100 | chevrolet | clean | 271.666045 | 2528.333955 | 2023-12-24 14:49:12+00:00 | good | https://bellingham.craigslist.org/cto/d/orcas-1993-chevy-x4/7700964734.html | Washington | silverado 1500 | white | gas | 4wd | truck | automatic |
| 2259071 | ithaca | 5900.0 | 153000.0 | 2008.0 | -76.411542 | 42.467108 | chevrolet | clean | 8164.384625 | -2264.384625 | 2024-05-04 21:03:10+00:00 | good | https://ithaca.craigslist.org/cto/d/etna-2008-chevrolet-silverado-1500-with/7743805658.html | New York | silverado 1500 | blue | gas | 4wd | pickup | automatic |
| 2259072 | miami | 3500.0 | 205342.0 | 2012.0 | -80.413000 | 25.700000 | chevrolet | clean | NaN | NaN | 2024-11-13 17:43:11+00:00 | None | https://miami.craigslist.org/mdc/cto/d/miami-chevrolet-silverado/7801918708.html | Florida | silverado 1500 | None | gas | None | pickup | automatic |
| 2259073 | dallas | 15000.0 | 73000.0 | 2013.0 | -96.782800 | 32.769100 | chevrolet | clean | 20057.705778 | -5057.705778 | 2024-01-20 16:38:43+00:00 | like new | https://dallas.craigslist.org/dal/cto/d/dallas-2013-chevrolet-silverado-1500/7709578896.html | Texas | silverado 1500 | white | gas | rwd | pickup | automatic |
| 2259074 | sacramento | 26900.0 | 64235.0 | 2007.0 | -122.340000 | 40.547000 | chevrolet | clean | 16545.615342 | 10354.384658 | 2024-05-04 08:05:56+00:00 | like new | https://sacramento.craigslist.org/cto/d/redding-2007-chevy-silverado-wheel/7743609333.html | California | silverado 1500 | black | gas | rwd | truck | automatic |
| 2259075 | inlandempire | 11000.0 | 230000.0 | 2003.0 | -117.138716 | 34.588333 | chevrolet | clean | 3449.801672 | 7550.198328 | 2024-04-28 14:15:16+00:00 | good | https://inlandempire.craigslist.org/cto/d/apple-valley-chevy-silverado/7741764548.html | California | silverado 1500 | grey | gas | fwd | truck | automatic |
| 2259076 | reno | 8950.0 | 160000.0 | 1998.0 | -119.776400 | 39.497200 | chevrolet | clean | 5992.459604 | 2957.540396 | 2024-07-28 09:24:02+00:00 | excellent | https://reno.craigslist.org/cto/d/reno-1998-chevy-step-side-short-bed-4x4/7770228753.html | Nevada | silverado 1500 | None | gas | 4wd | pickup | automatic |
Duplicate rows
Most frequently occurring
| location | price | odometer | year | long | lat | make | title | predicted_price | residual | time_posted | condition | url | state | model | paint | fuel | drive | type | transmission | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45753 | miami | 20900.0 | 88000.0 | 2018.0 | -80.207000 | 25.851200 | ford | clean | 11035.729321 | 9864.270679 | 2024-07-02 14:44:10+00:00 | like new | https://miami.craigslist.org/mdc/cto/d/miami-2018-ford-mustang-convertible/7762499156.html | Florida | mustang | white | gas | rwd | convertible | automatic | 110 |
| 11925 | miami | 1500.0 | 180000.0 | 2005.0 | -80.142356 | 26.295185 | scion | clean | 2606.942247 | -1106.942247 | 2024-06-18 12:29:42+00:00 | fair | https://miami.craigslist.org/pbc/cto/d/deerfield-beach-2005-scion-xb-in-fair/7758116281.html | Florida | xb | grey | gas | fwd | sedan | automatic | 95 |
| 20735 | miami | 4500.0 | 146683.0 | 2012.0 | -80.056000 | 26.618200 | kia | clean | NaN | NaN | 2024-07-02 13:40:53+00:00 | NaN | https://miami.craigslist.org/pbc/cto/d/boca-raton-2012-kia-rio/7762474333.html | Florida | rio | NaN | gas | NaN | sedan | automatic | 95 |
| 33414 | miami | 8500.0 | 154000.0 | 2006.0 | -80.084400 | 26.346200 | gmc | clean | 7957.950019 | 542.049981 | 2024-06-24 13:37:00+00:00 | good | https://miami.craigslist.org/pbc/cto/d/boca-raton-2006-gmc-sierra-1500-sle/7759974947.html | Florida | 1500 | grey | gas | rwd | pickup | automatic | 95 |
| 17297 | miami | 3500.0 | 228000.0 | 2005.0 | -80.358800 | 25.734300 | lexus | clean | 3605.466910 | -105.466910 | 2024-06-28 11:07:17+00:00 | good | https://miami.craigslist.org/mdc/cto/d/miami-2005-lexus-ls430/7761198368.html | Florida | ls | silver | gas | fwd | sedan | automatic | 90 |
| 25753 | miami | 5900.0 | 101000.0 | 2011.0 | -80.404600 | 25.596800 | ford | rebuilt | 10683.655656 | -4783.655656 | 2024-06-24 21:56:57+00:00 | like new | https://miami.craigslist.org/mdc/cto/d/miami-2011-ford-mustang/7760134705.html | Florida | mustang | black | gas | rwd | convertible | manual | 90 |
| 13916 | miami | 2500.0 | 220000.0 | 2004.0 | -80.195000 | 26.585000 | bmw | clean | NaN | NaN | 2024-06-08 08:51:23+00:00 | NaN | https://miami.craigslist.org/pbc/cto/d/lake-worth-2004-bmw-325i-ice-cold-ac/7754977134.html | Florida | 2 | black | gas | NaN | sedan | automatic | 85 |
| 37456 | miami | 10500.0 | 162000.0 | 2015.0 | -80.380900 | 26.100300 | lexus | clean | 8638.671269 | 1861.328731 | 2024-06-23 22:39:29+00:00 | good | https://miami.craigslist.org/brw/cto/d/fort-lauderdale-lexus-ct200h-2015/7759810242.html | Florida | ct | silver | hybrid | NaN | hatchback | automatic | 85 |
| 42255 | miami | 14900.0 | 44000.0 | 2019.0 | -80.418629 | 25.598488 | gmc | rebuilt | 20861.233815 | -5961.233815 | 2024-06-26 12:51:10+00:00 | like new | https://miami.craigslist.org/mdc/cto/d/miami-2019-gmc-acadia/7760605245.html | Florida | acadia | silver | gas | fwd | SUV | automatic | 85 |
| 19926 | miami | 4300.0 | 129000.0 | 2010.0 | -80.121300 | 26.263500 | volkswagen | clean | 5231.551031 | -931.551031 | 2024-06-24 21:33:50+00:00 | excellent | https://miami.craigslist.org/brw/cto/d/pompano-beach-2010-vw-jetta/7760130431.html | Florida | jetta | black | gas | NaN | sedan | automatic | 80 |